package com.itrui.commodity.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.itrui.commodity.common.CustomException;
import com.itrui.commodity.dto.SetmealDto;
import com.itrui.commodity.pojo.Setmeal;
import com.itrui.commodity.pojo.SetmealProduct;
import com.itrui.commodity.service.SetmealProductService;
import com.itrui.commodity.service.SetmealService;
import com.itrui.commodity.mapper.SetmealMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.stream.Collectors;

/**
* @author 蕊蕤的小腿肚子
* @description 针对表【setmeal(套餐)】的数据库操作Service实现
* @createDate 2022-08-17 19:12:17
*/
@Service
public class SetmealServiceImpl extends ServiceImpl<SetmealMapper, Setmeal>
    implements SetmealService{
    @Autowired
    private SetmealProductService setmealProductService;

    /**
     * 新增套餐，同时需要保存套餐和商品的关联关系
     * @param setmealDto
     */
    @Transactional
    public void saveWithProduct(SetmealDto setmealDto) {
        //保存套餐的基本信息，操作setmeal，执行insert操作
        this.save(setmealDto);

        List<SetmealProduct> setmealProducts = setmealDto.getSetmealProducts();

        setmealProducts.stream().map((item) -> {

            item.setSetmealId(String.valueOf(setmealDto.getId()));

            return item;
        }).collect(Collectors.toList());

        //保存套餐和商品的关联信息，操作setmeal_product,执行insert操作
        setmealProductService.saveBatch(setmealProducts);
    }

    /**
     * 删除套餐，同时需要删除套餐和商品的关联数据
     * @param ids
     */
    @Transactional
    public void removeWithProduct(List<Long> ids) {
        //select count(*) from setmeal where id in (1,2,3) and status = 1
        //查询套餐状态，确定是否可用删除
        LambdaQueryWrapper<Setmeal> queryWrapper = new LambdaQueryWrapper();
        queryWrapper.in(Setmeal::getId,ids);
        queryWrapper.eq(Setmeal::getStatus,1);

        int count = this.count(queryWrapper);

        if(count > 0){
            //如果不能删除，抛出一个业务异常
            throw new CustomException("套餐正在售卖中，不能删除");
        }

        //如果可以删除，先删除套餐表中的数据---setmeal
        this.removeByIds(ids);

        //delete from setmeal_Product where setmeal_id in (1,2,3)
        LambdaQueryWrapper<SetmealProduct> lambdaQueryWrapper = new LambdaQueryWrapper<>();
        lambdaQueryWrapper.in(SetmealProduct::getSetmealId,ids);
        //删除关系表中的数据----setmeal_Product
        setmealProductService.remove(lambdaQueryWrapper);
    }
}




